MCAD CERTIFICATION TRAINING CURRICULUM

To become an MCAD, candidates must pass three certification exams: two core exams and one elective exam.
  1. Exam 70-229: Databases with Microsoft SQL Server 2000 Enterprise Edition
  2. Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
  3. Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework

I. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
    • 1.75 Hours

  • SQL Server 2000 Databases
    • 1.75 Hours

  • Designing and Implementing Security in SQL Server 2000
    • 1.25 Hours

  • The SQL Server 2000 Logical Data Model
    • 2.50 Hours

  • Using T-SQL in SQL Server 2000
    • 3 Hours

  • SQL Server 2000 Indexes
    • 2 Hours

  • SQL Server 2000 Programming and Business Logic
    • 2.75 Hours

  • SQL Server 2000 Transactions and Distributed Data
    • 1.75 Hours

  • Analyzing and Optimizing SQL Server 2000 Queries
    • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
    • 1.50 Hours

  • SQL Server 2000, XML and the Web
    • 1.50 Hours


    II. Exam 70-306: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

  • Introducing Microsoft .NET
    • 4.50 Hours

  • Moving to Visual Basic .NET
    • 5.25 Hours

  • Advanced Language Features of Microsoft VB.NET
    • 5.25 Hours

  • Windows Forms and ASP.NET
    • 4.50 Hours

  • ADO.NET Connections and Commands
    • 4.25 Hours

  • Building ADO.NET DataSets
    • 4.25 Hours

  • Advanced ADO.NET Programming
    • 4.50 Hours

  • Application Deployment in .NET
    • 2 Hours

  • Deployment of Windows-Based .NET Applications
    • 6.25 Hours

  • Testing and Instrumenting VB.NET Applications
    • 5 Hours

  • Assemblies and Configuration in .NET
    • 3.25 Hours

  • Security with VB.NET
    • 5.75 Hours

  • Windows Forms and Controls in VB.NET
    • 3.25 Hours

  • Customizing Controls and Events in VB.NET
    • 2.25 Hours

  • Input Validation and Error Handling in VB.NET
    • 2 Hours

  • Adding Services and Components in VB.NET
    • 2.25 Hours

  • Printing, Reporting, Help, Accessibility, Localization, and Globalization in VB.NET
    • 3 Hours


    III. Exam #70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework

  • Introducing Microsoft .NET
    • 4.50 Hours

  • XML Web Services and Microsoft .NET
    • 3.25 Hours

  • Building Web Services and Web-Service Clients with Microsoft.NET
    • 2.75 Hours

  • Moving to Visual Basic .NET
    • 5.25 Hours

  • Advanced Language Features of Microsoft VB.NET
    • 5.25 Hours

  • Windows Forms and ASP.NET
    • 4.50 Hours

  • ADO.NET Connections and Commands
    • 4.25 Hours

  • Building ADO.NET DataSets
    • 4.25 Hours

  • Advanced ADO.NET Programming
    • 4.50 Hours

  • Assemblies and Configuration in .NET
    • 3.25 Hours

  • Security with VB.NET
    • 5.75 Hours

  • Testing and Instrumenting Web Applications in VB.NET
    • 3 Hours

  • Web Application Tracing and Debugging in VB.NET
    • 3.75 Hours

  • Web Application Maintenance in VB.NET
    • 3.25 Hours

  • Windows Services in VB.NET
    • 2 Hours

  • Interoperability and Serviced Components
    • 3.25 Hours

  • .NET Remoting
    • 4 Hours

  • XML Data Access in VB.NET
    • 3 Hours

  • Planning and Starting the Deployment of a .NET Web Application
    • 2.25 Hours

  • Using Visual Studio .NET to Deploy a Web-based Application
    • 2.75 Hours